SELECT * FROM T_DischargePoints WHERE dcpState=1 AND uwwCode NOT IN (SELECT uwwCode FROM T_UWWTPS)

---